﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ContentsDS" targetNamespace="http://tempuri.org/ContentsDS.xsd" xmlns:mstns="http://tempuri.org/ContentsDS.xsd" xmlns="http://tempuri.org/ContentsDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="contentsConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="contentsConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PaliTextReader2.Properties.Settings.GlobalReference.Default.contentsConnectionString" Provider="Microsoft.SqlServerCe.Client.3.5" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="contentsConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="contentsConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PaliTextReader2.Properties.Settings.GlobalReference.Default.contentsConnectionString1" Provider="Microsoft.SqlServerCe.Client.3.5" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CollectionsTableAdapter" GeneratorDataComponentClassName="CollectionsTableAdapter" Name="Collections" UserDataComponentName="CollectionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Collections" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Collections] WHERE (([CollectionID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CollectionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Collections] ([ParentID], [Title], [FilePattern], [HasPTSPages]) VALUES (@p1, @p2, @p3, @p4)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FilePattern" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasPTSPages" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     CollectionID, ParentID, Title, FilePattern, HasPTSPages
FROM         Collections</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Collections] SET [ParentID] = @p1, [Title] = @p2, [FilePattern] = @p3, [HasPTSPages] = @p4 WHERE (([CollectionID] = @p5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FilePattern" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasPTSPages" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CollectionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CollectionID" DataSetColumn="CollectionID" />
              <Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="FilePattern" DataSetColumn="FilePattern" />
              <Mapping SourceColumn="HasPTSPages" DataSetColumn="HasPTSPages" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Collections" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetChildItems" GetMethodModifier="Public" GetMethodName="GetChildItems" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetChildItems" UserSourceName="GetChildItems">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     CollectionID, FilePattern, HasPTSPages, ParentID, Title
FROM         Collections
WHERE     (ParentID = @ParentID) AND (@HasPTSPages = 1) AND (HasPTSPages = 1) OR
                      (ParentID = @ParentID) AND (@HasPTSPages = 0)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ParentID" ColumnName="ParentID" DataSourceName="Collections" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="HasPTSPages" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Boolean" Direction="Input" ParameterName="@HasPTSPages" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Collections" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetCollection" GetMethodModifier="Public" GetMethodName="GetCollection" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCollection" UserSourceName="GetCollection">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CollectionID, FilePattern, HasPTSPages, ParentID, Title FROM Collections WHERE (CollectionID = @CollectionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CollectionID" ColumnName="CollectionID" DataSourceName="Collections" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@CollectionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CollectionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Collections" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetRootItems" GetMethodModifier="Public" GetMethodName="GetRootItems" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetRootItems" UserSourceName="GetRootItems">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     CollectionID, FilePattern, HasPTSPages, ParentID, Title
FROM         Collections
WHERE     (ParentID IS NULL) AND (@HasPTSPages = 1) AND (HasPTSPages = 1) OR
                      (ParentID IS NULL) AND (@HasPTSPages = 0)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="HasPTSPages" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Boolean" Direction="Input" ParameterName="@HasPTSPages" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PTSPagesTableAdapter" GeneratorDataComponentClassName="PTSPagesTableAdapter" Name="PTSPages" UserDataComponentName="PTSPagesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="PTSPages" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [PTSPages] WHERE (([ID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [PTSPages] ([FileID], [VolumeID], [PageMin], [PageMax]) VALUES (@p1, @p2, @p3, @p4)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FileID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VolumeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageMin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageMax" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [ID], [FileID], [VolumeID], [PageMin], [PageMax] FROM [PTSPages]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [PTSPages] SET [FileID] = @p1, [VolumeID] = @p2, [PageMin] = @p3, [PageMax] = @p4 WHERE (([ID] = @p5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FileID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VolumeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageMin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PageMax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="FileID" DataSetColumn="FileID" />
              <Mapping SourceColumn="VolumeID" DataSetColumn="VolumeID" />
              <Mapping SourceColumn="PageMin" DataSetColumn="PageMin" />
              <Mapping SourceColumn="PageMax" DataSetColumn="PageMax" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FindFileByPage" Modifier="Public" Name="FindFileByPage" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FindFileByPage">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     MAX(PTSPages.FileID) AS Expr1
FROM         PTSPages INNER JOIN
                      Files ON PTSPages.FileID = Files.FileID
WHERE     (PTSPages.VolumeID = @VolumeID) AND (@Page BETWEEN PTSPages.PageMin AND PTSPages.PageMax) AND (Files.CollectionID = @CollectionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="VolumeID" ColumnName="VolumeID" DataSourceName="PTSPages" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@VolumeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="VolumeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Page" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@Page" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CollectionID" ColumnName="CollectionID" DataSourceName="Files" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@CollectionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CollectionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FilesTableAdapter" GeneratorDataComponentClassName="FilesTableAdapter" Name="Files" UserDataComponentName="FilesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Files] WHERE (([FileID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FileID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Files] ([FileName], [CollectionID], [ShowBold], [ShowFont]) VALUES (@p1, @p2, @p3, @p4)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FileName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CollectionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ShowBold" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ShowFont" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     FileID, FileName, CollectionID, ShowBold, ShowFont
FROM         Files</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Files] SET [FileName] = @p1, [CollectionID] = @p2, [ShowBold] = @p3, [ShowFont] = @p4 WHERE (([FileID] = @p5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FileName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CollectionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ShowBold" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ShowFont" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FileID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FileID" DataSetColumn="FileID" />
              <Mapping SourceColumn="FileName" DataSetColumn="FileName" />
              <Mapping SourceColumn="CollectionID" DataSetColumn="CollectionID" />
              <Mapping SourceColumn="ShowBold" DataSetColumn="ShowBold" />
              <Mapping SourceColumn="ShowFont" DataSetColumn="ShowFont" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="AddShowBoldColumn" Modifier="Public" Name="AddShowBoldColumn" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="AddShowBoldColumn">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>ALTER TABLE Files ADD COLUMN ShowBold bit DEFAULT (1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="AddShowFontColumn" Modifier="Public" Name="AddShowFontColumn" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="AddShowFontColumn">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>ALTER TABLE Files ADD COLUMN ShowFont bit DEFAULT (1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CheckColumnExists" Modifier="Public" Name="CheckColumnExists" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="CheckColumnExists">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*)
FROM         INFORMATION_SCHEMA.COLUMNS AS C
WHERE     (C.TABLE_NAME = 'Files') AND (C.COLUMN_NAME = @ColumnNameParam)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ColumnNameParam" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="@ColumnNameParam" Precision="0" ProviderType="NVarChar" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Files" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetByCollection" GetMethodModifier="Public" GetMethodName="GetByCollection" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetByCollection" UserSourceName="GetByCollection">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CollectionID, FileID, FileName, ShowBold, ShowFont FROM Files WHERE (CollectionID = @CollectionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CollectionID" ColumnName="CollectionID" DataSourceName="Files" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@CollectionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CollectionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Files" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetByFileID" GetMethodModifier="Public" GetMethodName="GetByFileID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetByFileID" UserSourceName="GetByFileID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CollectionID, FileID, FileName, ShowBold, ShowFont FROM Files WHERE (FileID = @FileID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="FileID" ColumnName="FileID" DataSourceName="Files" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@FileID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FileID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Files" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetByName" GetMethodModifier="Public" GetMethodName="GetByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetByName" UserSourceName="GetByName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CollectionID, FileID, FileName, ShowBold, ShowFont FROM Files WHERE (FileName = @FileName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="FileName" ColumnName="FileName" DataSourceName="Files" DataTypeServer="nvarchar(255)" DbType="String" Direction="Input" ParameterName="@FileName" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumn="FileName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Files" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetByNode" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetByNode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetByNode" UserSourceName="GetByNode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Files.CollectionID, Files.FileID, Files.FileName, Files.ShowBold, Files.ShowFont FROM Files INNER JOIN Nodes ON Files.FileID = Nodes.FileID WHERE (Nodes.NodeID = @NodeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="NodeID" ColumnName="NodeID" DataSourceName="Nodes" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@NodeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="NodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateFlags" Modifier="Public" Name="UpdateFlags" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="UpdateFlags">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [Files] SET  [ShowBold] = @ShowBoldParam, [ShowFont] = @ShowFontParam WHERE (([FileID] = @FileIDParam))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ShowBoldParam" ColumnName="ShowBold" DataSourceName="Files" DataTypeServer="bit(2)" DbType="Boolean" Direction="Input" ParameterName="@ShowBoldParam" Precision="0" ProviderType="Bit" Scale="0" Size="2" SourceColumn="ShowBold" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ShowFontParam" ColumnName="ShowFont" DataSourceName="Files" DataTypeServer="bit(2)" DbType="Boolean" Direction="Input" ParameterName="@ShowFontParam" Precision="0" ProviderType="Bit" Scale="0" Size="2" SourceColumn="ShowFont" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="FileIDParam" ColumnName="FileID" DataSourceName="Files" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@FileIDParam" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FileID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NodesTableAdapter" GeneratorDataComponentClassName="NodesTableAdapter" Name="Nodes" UserDataComponentName="NodesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Nodes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     NodeID, ParentID, NodeTitle, HasChildren, BookmarkName, FileID, NodeTitleNoDiac
FROM         Nodes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="NodeID" DataSetColumn="NodeID" />
              <Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
              <Mapping SourceColumn="NodeTitle" DataSetColumn="NodeTitle" />
              <Mapping SourceColumn="HasChildren" DataSetColumn="HasChildren" />
              <Mapping SourceColumn="BookmarkName" DataSetColumn="BookmarkName" />
              <Mapping SourceColumn="FileID" DataSetColumn="FileID" />
              <Mapping SourceColumn="NodeTitleNoDiac" DataSetColumn="NodeTitleNoDiac" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Nodes" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="FindNodesNoDiac" GetMethodModifier="Public" GetMethodName="FindNodesNoDiac" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="FindNodesNoDiac" UserSourceName="FindNodesNoDiac">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     NodeID, ParentID, NodeTitle, HasChildren, BookmarkName, FileID, NodeTitleNoDiac
FROM         Nodes
WHERE     (@SearchMode = 1) AND (NodeTitleNoDiac LIKE @Title + '%') OR
                      (@SearchMode = 0) AND (NodeTitleNoDiac LIKE '%' + @Title + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SearchMode" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@SearchMode" Precision="0" ProviderType="Int" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Title" ColumnName="NodeTitleNoDiac" DataSourceName="Nodes" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="NodeTitleNoDiac" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Nodes" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="FindNodesPali" GetMethodModifier="Public" GetMethodName="FindNodesPali" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="FindNodesPali" UserSourceName="FindNodesPali">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     NodeID, ParentID, NodeTitle, HasChildren, BookmarkName, FileID, NodeTitleNoDiac
FROM         Nodes
WHERE     (@SearchMode = 1) AND (NodeTitle LIKE @Title + '%') OR
                      (@SearchMode = 0) AND (NodeTitle LIKE '%' + @Title + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SearchMode" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@SearchMode" Precision="0" ProviderType="Int" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Title" ColumnName="NodeTitle" DataSourceName="Nodes" DataTypeServer="nvarchar(255)" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumn="NodeTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Nodes" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetByFileBookmark" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetByFileBookmark" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetByFileBookmark" UserSourceName="GetByFileBookmark">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     NodeID, ParentID, NodeTitle, HasChildren, BookmarkName, FileID, NodeTitleNoDiac
FROM         Nodes
WHERE FileID=@FileID AND BookmarkName=@BookmarkName</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="FileID" ColumnName="FileID" DataSourceName="Nodes" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@FileID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FileID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="BookmarkName" ColumnName="BookmarkName" DataSourceName="Nodes" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@BookmarkName" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="BookmarkName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Nodes" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetFileName" GetMethodModifier="Public" GetMethodName="GetFileName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetFileName" UserSourceName="GetFileName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     TOP (1) NodeID, ParentID, NodeTitle, HasChildren, BookmarkName, FileID, NodeTitleNoDiac
FROM         Nodes
WHERE     (FileID = @FileID)
ORDER BY ParentID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="FileID" ColumnName="FileID" DataSourceName="Nodes" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@FileID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FileID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Nodes" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetNode" GetMethodModifier="Public" GetMethodName="GetNode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetNode" UserSourceName="GetNode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     NodeID, ParentID, NodeTitle, HasChildren, BookmarkName, FileID, NodeTitleNoDiac
FROM         Nodes
WHERE NodeID=@NodeID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="NodeID" ColumnName="NodeID" DataSourceName="Nodes" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@NodeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="NodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Nodes" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetNodesByParent" GetMethodModifier="Public" GetMethodName="GetNodesByParent" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetNodesByParent" UserSourceName="GetNodesByParent">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT BookmarkName, FileID, HasChildren, NodeID, NodeTitle, NodeTitleNoDiac, ParentID FROM Nodes WHERE (ParentID = @ParentID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ParentID" ColumnName="ParentID" DataSourceName="Nodes" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Nodes" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetRootNodes" GetMethodModifier="Public" GetMethodName="GetRootNodes" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetRootNodes" UserSourceName="GetRootNodes">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT BookmarkName, FileID, HasChildren, NodeID, NodeTitle, NodeTitleNoDiac, ParentID FROM Nodes WHERE (ParentID IS NULL)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PTSPagesAggTableAdapter" GeneratorDataComponentClassName="PTSPagesAggTableAdapter" Name="PTSPagesAgg" UserDataComponentName="PTSPagesAggTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="PTSPages" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     PTSPages.VolumeID, MIN(PTSPages.PageMin) AS MinPage, MAX(PTSPages.PageMax) AS MaxPage
FROM         PTSPages INNER JOIN
                      Files ON PTSPages.FileID = Files.FileID
WHERE     (Files.CollectionID = @CollectionID)
GROUP BY PTSPages.VolumeID
ORDER BY PTSPages.VolumeID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CollectionID" ColumnName="CollectionID" DataSourceName="Files" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@CollectionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CollectionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VolumeID" DataSetColumn="VolumeID" />
              <Mapping SourceColumn="MinPage" DataSetColumn="MinPage" />
              <Mapping SourceColumn="MaxPage" DataSetColumn="MaxPage" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="PTSPages" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="FindByFile" GetMethodModifier="Public" GetMethodName="FindByFile" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="FindByFile" UserSourceName="FindByFile">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [VolumeID], [PageMin] As MinPage, [PageMax] As MaxPage FROM [PTSPages]
WHERE FileID=@FileID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="FileID" ColumnName="FileID" DataSourceName="PTSPages" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@FileID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FileID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DictionaryContentTableAdapter" GeneratorDataComponentClassName="DictionaryContentTableAdapter" Name="DictionaryContent" UserDataComponentName="DictionaryContentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="DictionaryContent" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [DictionaryContent] WHERE (([EntryID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [DictionaryContent] ([Keyword], [Translation], [KeywordNoDiac], [DictionaryID]) VALUES (@p1, @p2, @p3, @p4)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Keyword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Translation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeywordNoDiac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DictionaryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT EntryID, Keyword, Translation, KeywordNoDiac, DictionaryID FROM DictionaryContent</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [DictionaryContent] SET [Keyword] = @p1, [Translation] = @p2, [KeywordNoDiac] = @p3, [DictionaryID] = @p4 WHERE (([EntryID] = @p5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Keyword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Translation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeywordNoDiac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DictionaryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EntryID" DataSetColumn="EntryID" />
              <Mapping SourceColumn="Keyword" DataSetColumn="Keyword" />
              <Mapping SourceColumn="Translation" DataSetColumn="Translation" />
              <Mapping SourceColumn="KeywordNoDiac" DataSetColumn="KeywordNoDiac" />
              <Mapping SourceColumn="DictionaryID" DataSetColumn="DictionaryID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="DictionaryContent" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="FindNoDiac" GetMethodModifier="Public" GetMethodName="FindNoDiac" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="FindNoDiac" UserSourceName="FindNoDiac">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     DictionaryID, EntryID, Keyword, KeywordNoDiac, Translation
FROM         DictionaryContent
WHERE     (@SearchMode = 0) AND (DictionaryID = @DictionaryID) AND (KeywordNoDiac LIKE @Keyword + N'%') OR
                      (@SearchMode = 1) AND (DictionaryID = @DictionaryID) AND (KeywordNoDiac LIKE N'%' + @Keyword + N'%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SearchMode" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@SearchMode" Precision="0" ProviderType="Int" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DictionaryID" ColumnName="DictionaryID" DataSourceName="DictionaryContent" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@DictionaryID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DictionaryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Keyword" ColumnName="KeywordNoDiac" DataSourceName="DictionaryContent" DataTypeServer="nvarchar(255)" DbType="String" Direction="Input" ParameterName="@Keyword" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumn="KeywordNoDiac" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="DictionaryContent" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="FindPali" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="FindPali" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="FindPali" UserSourceName="FindPali">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     DictionaryID, EntryID, Keyword, KeywordNoDiac, Translation
FROM         DictionaryContent
WHERE     (@SearchMode = 0) AND (DictionaryID = @DictionaryID) AND (Keyword LIKE @Keyword + N'%') OR
                      (@SearchMode = 1) AND (DictionaryID = @DictionaryID) AND (Keyword LIKE N'%' + @Keyword + N'%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SearchMode" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@SearchMode" Precision="0" ProviderType="Int" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DictionaryID" ColumnName="DictionaryID" DataSourceName="DictionaryContent" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@DictionaryID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DictionaryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Keyword" ColumnName="Keyword" DataSourceName="DictionaryContent" DataTypeServer="nvarchar(255)" DbType="String" Direction="Input" ParameterName="@Keyword" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumn="Keyword" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="DictionaryContent" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetTranslation" GetMethodModifier="Public" GetMethodName="GetTranslation" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetTranslation" UserSourceName="GetTranslation">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DictionaryID, EntryID, Keyword, KeywordNoDiac, Translation FROM DictionaryContent WHERE (EntryID = @EntryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="EntryID" ColumnName="EntryID" DataSourceName="DictionaryContent" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@EntryID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DictionariesTableAdapter" GeneratorDataComponentClassName="DictionariesTableAdapter" Name="Dictionaries" UserDataComponentName="DictionariesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="contentsConnectionString (Settings)" DbObjectName="Dictionaries" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Dictionaries] WHERE (([DictionaryID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DictionaryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Dictionaries] ([DictionaryID], [Name]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DictionaryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [DictionaryID], [Name] FROM [Dictionaries]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Dictionaries] SET [DictionaryID] = @p1, [Name] = @p2 WHERE (([DictionaryID] = @p3))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DictionaryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DictionaryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DictionaryID" DataSetColumn="DictionaryID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ContentsDS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ContentsDS" msprop:Generator_DataSetName="ContentsDS" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Collections" msprop:Generator_UserTableName="Collections" msprop:Generator_RowDeletedName="CollectionsRowDeleted" msprop:Generator_RowChangedName="CollectionsRowChanged" msprop:Generator_RowClassName="CollectionsRow" msprop:Generator_RowChangingName="CollectionsRowChanging" msprop:Generator_RowEvArgName="CollectionsRowChangeEvent" msprop:Generator_RowEvHandlerName="CollectionsRowChangeEventHandler" msprop:Generator_TableClassName="CollectionsDataTable" msprop:Generator_TableVarName="tableCollections" msprop:Generator_RowDeletingName="CollectionsRowDeleting" msprop:Generator_TablePropName="Collections">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CollectionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="CollectionID" msprop:Generator_ColumnVarNameInTable="columnCollectionID" msprop:Generator_ColumnPropNameInRow="CollectionID" msprop:Generator_ColumnPropNameInTable="CollectionIDColumn" type="xs:int" />
              <xs:element name="ParentID" msprop:Generator_UserColumnName="ParentID" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FilePattern" msprop:Generator_UserColumnName="FilePattern" msprop:Generator_ColumnVarNameInTable="columnFilePattern" msprop:Generator_ColumnPropNameInRow="FilePattern" msprop:Generator_ColumnPropNameInTable="FilePatternColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HasPTSPages" msprop:Generator_UserColumnName="HasPTSPages" msprop:Generator_ColumnVarNameInTable="columnHasPTSPages" msprop:Generator_ColumnPropNameInRow="HasPTSPages" msprop:Generator_ColumnPropNameInTable="HasPTSPagesColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PTSPages" msprop:Generator_UserTableName="PTSPages" msprop:Generator_RowDeletedName="PTSPagesRowDeleted" msprop:Generator_RowChangedName="PTSPagesRowChanged" msprop:Generator_RowClassName="PTSPagesRow" msprop:Generator_RowChangingName="PTSPagesRowChanging" msprop:Generator_RowEvArgName="PTSPagesRowChangeEvent" msprop:Generator_RowEvHandlerName="PTSPagesRowChangeEventHandler" msprop:Generator_TableClassName="PTSPagesDataTable" msprop:Generator_TableVarName="tablePTSPages" msprop:Generator_RowDeletingName="PTSPagesRowDeleting" msprop:Generator_TablePropName="PTSPages">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="FileID" msprop:Generator_UserColumnName="FileID" msprop:Generator_ColumnVarNameInTable="columnFileID" msprop:Generator_ColumnPropNameInRow="FileID" msprop:Generator_ColumnPropNameInTable="FileIDColumn" type="xs:int" />
              <xs:element name="VolumeID" msprop:Generator_UserColumnName="VolumeID" msprop:Generator_ColumnVarNameInTable="columnVolumeID" msprop:Generator_ColumnPropNameInRow="VolumeID" msprop:Generator_ColumnPropNameInTable="VolumeIDColumn" type="xs:int" />
              <xs:element name="PageMin" msprop:Generator_UserColumnName="PageMin" msprop:Generator_ColumnVarNameInTable="columnPageMin" msprop:Generator_ColumnPropNameInRow="PageMin" msprop:Generator_ColumnPropNameInTable="PageMinColumn" type="xs:int" />
              <xs:element name="PageMax" msprop:Generator_UserColumnName="PageMax" msprop:Generator_ColumnVarNameInTable="columnPageMax" msprop:Generator_ColumnPropNameInRow="PageMax" msprop:Generator_ColumnPropNameInTable="PageMaxColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Files" msprop:Generator_UserTableName="Files" msprop:Generator_RowDeletedName="FilesRowDeleted" msprop:Generator_RowChangedName="FilesRowChanged" msprop:Generator_RowClassName="FilesRow" msprop:Generator_RowChangingName="FilesRowChanging" msprop:Generator_RowEvArgName="FilesRowChangeEvent" msprop:Generator_RowEvHandlerName="FilesRowChangeEventHandler" msprop:Generator_TableClassName="FilesDataTable" msprop:Generator_TableVarName="tableFiles" msprop:Generator_RowDeletingName="FilesRowDeleting" msprop:Generator_TablePropName="Files">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FileID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="FileID" msprop:Generator_ColumnVarNameInTable="columnFileID" msprop:Generator_ColumnPropNameInRow="FileID" msprop:Generator_ColumnPropNameInTable="FileIDColumn" type="xs:int" />
              <xs:element name="FileName" msprop:Generator_UserColumnName="FileName" msprop:Generator_ColumnVarNameInTable="columnFileName" msprop:Generator_ColumnPropNameInRow="FileName" msprop:Generator_ColumnPropNameInTable="FileNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CollectionID" msprop:Generator_UserColumnName="CollectionID" msprop:Generator_ColumnVarNameInTable="columnCollectionID" msprop:Generator_ColumnPropNameInRow="CollectionID" msprop:Generator_ColumnPropNameInTable="CollectionIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ShowBold" msprop:Generator_UserColumnName="ShowBold" msprop:Generator_ColumnVarNameInTable="columnShowBold" msprop:Generator_ColumnPropNameInRow="ShowBold" msprop:Generator_ColumnPropNameInTable="ShowBoldColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ShowFont" msprop:Generator_UserColumnName="ShowFont" msprop:Generator_ColumnVarNameInTable="columnShowFont" msprop:Generator_ColumnPropNameInRow="ShowFont" msprop:Generator_ColumnPropNameInTable="ShowFontColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Nodes" msprop:Generator_UserTableName="Nodes" msprop:Generator_RowDeletedName="NodesRowDeleted" msprop:Generator_RowChangedName="NodesRowChanged" msprop:Generator_RowClassName="NodesRow" msprop:Generator_RowChangingName="NodesRowChanging" msprop:Generator_RowEvArgName="NodesRowChangeEvent" msprop:Generator_RowEvHandlerName="NodesRowChangeEventHandler" msprop:Generator_TableClassName="NodesDataTable" msprop:Generator_TableVarName="tableNodes" msprop:Generator_RowDeletingName="NodesRowDeleting" msprop:Generator_TablePropName="Nodes">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="NodeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="NodeID" msprop:Generator_ColumnVarNameInTable="columnNodeID" msprop:Generator_ColumnPropNameInRow="NodeID" msprop:Generator_ColumnPropNameInTable="NodeIDColumn" type="xs:int" />
              <xs:element name="ParentID" msprop:Generator_UserColumnName="ParentID" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NodeTitle" msprop:Generator_UserColumnName="NodeTitle" msprop:Generator_ColumnVarNameInTable="columnNodeTitle" msprop:Generator_ColumnPropNameInRow="NodeTitle" msprop:Generator_ColumnPropNameInTable="NodeTitleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HasChildren" msprop:Generator_UserColumnName="HasChildren" msprop:Generator_ColumnVarNameInTable="columnHasChildren" msprop:Generator_ColumnPropNameInRow="HasChildren" msprop:Generator_ColumnPropNameInTable="HasChildrenColumn" type="xs:boolean" />
              <xs:element name="BookmarkName" msprop:Generator_UserColumnName="BookmarkName" msprop:Generator_ColumnVarNameInTable="columnBookmarkName" msprop:Generator_ColumnPropNameInRow="BookmarkName" msprop:Generator_ColumnPropNameInTable="BookmarkNameColumn" type="xs:int" minOccurs="0" />
              <xs:element name="FileID" msprop:Generator_UserColumnName="FileID" msprop:Generator_ColumnVarNameInTable="columnFileID" msprop:Generator_ColumnPropNameInRow="FileID" msprop:Generator_ColumnPropNameInTable="FileIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NodeTitleNoDiac" msprop:Generator_UserColumnName="NodeTitleNoDiac" msprop:Generator_ColumnVarNameInTable="columnNodeTitleNoDiac" msprop:Generator_ColumnPropNameInRow="NodeTitleNoDiac" msprop:Generator_ColumnPropNameInTable="NodeTitleNoDiacColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PTSPagesAgg" msprop:Generator_UserTableName="PTSPagesAgg" msprop:Generator_RowDeletedName="PTSPagesAggRowDeleted" msprop:Generator_RowChangedName="PTSPagesAggRowChanged" msprop:Generator_RowClassName="PTSPagesAggRow" msprop:Generator_RowChangingName="PTSPagesAggRowChanging" msprop:Generator_RowEvArgName="PTSPagesAggRowChangeEvent" msprop:Generator_RowEvHandlerName="PTSPagesAggRowChangeEventHandler" msprop:Generator_TableClassName="PTSPagesAggDataTable" msprop:Generator_TableVarName="tablePTSPagesAgg" msprop:Generator_RowDeletingName="PTSPagesAggRowDeleting" msprop:Generator_TablePropName="PTSPagesAgg">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VolumeID" msprop:Generator_UserColumnName="VolumeID" msprop:Generator_ColumnVarNameInTable="columnVolumeID" msprop:Generator_ColumnPropNameInRow="VolumeID" msprop:Generator_ColumnPropNameInTable="VolumeIDColumn" type="xs:int" />
              <xs:element name="MinPage" msdata:ReadOnly="true" msprop:Generator_UserColumnName="MinPage" msprop:Generator_ColumnVarNameInTable="columnMinPage" msprop:Generator_ColumnPropNameInRow="MinPage" msprop:Generator_ColumnPropNameInTable="MinPageColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MaxPage" msdata:ReadOnly="true" msprop:Generator_UserColumnName="MaxPage" msprop:Generator_ColumnVarNameInTable="columnMaxPage" msprop:Generator_ColumnPropNameInRow="MaxPage" msprop:Generator_ColumnPropNameInTable="MaxPageColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DictionaryContent" msprop:Generator_UserTableName="DictionaryContent" msprop:Generator_RowDeletedName="DictionaryContentRowDeleted" msprop:Generator_RowChangedName="DictionaryContentRowChanged" msprop:Generator_RowClassName="DictionaryContentRow" msprop:Generator_RowChangingName="DictionaryContentRowChanging" msprop:Generator_RowEvArgName="DictionaryContentRowChangeEvent" msprop:Generator_RowEvHandlerName="DictionaryContentRowChangeEventHandler" msprop:Generator_TableClassName="DictionaryContentDataTable" msprop:Generator_TableVarName="tableDictionaryContent" msprop:Generator_RowDeletingName="DictionaryContentRowDeleting" msprop:Generator_TablePropName="DictionaryContent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EntryID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="EntryID" msprop:Generator_ColumnPropNameInRow="EntryID" msprop:Generator_ColumnVarNameInTable="columnEntryID" msprop:Generator_ColumnPropNameInTable="EntryIDColumn" type="xs:int" />
              <xs:element name="Keyword" msprop:Generator_UserColumnName="Keyword" msprop:Generator_ColumnPropNameInRow="Keyword" msprop:Generator_ColumnVarNameInTable="columnKeyword" msprop:Generator_ColumnPropNameInTable="KeywordColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Translation" msprop:Generator_UserColumnName="Translation" msprop:Generator_ColumnPropNameInRow="Translation" msprop:Generator_ColumnVarNameInTable="columnTranslation" msprop:Generator_ColumnPropNameInTable="TranslationColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870911" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KeywordNoDiac" msprop:Generator_UserColumnName="KeywordNoDiac" msprop:Generator_ColumnPropNameInRow="KeywordNoDiac" msprop:Generator_ColumnVarNameInTable="columnKeywordNoDiac" msprop:Generator_ColumnPropNameInTable="KeywordNoDiacColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DictionaryID" msprop:Generator_UserColumnName="DictionaryID" msprop:Generator_ColumnPropNameInRow="DictionaryID" msprop:Generator_ColumnVarNameInTable="columnDictionaryID" msprop:Generator_ColumnPropNameInTable="DictionaryIDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Dictionaries" msprop:Generator_UserTableName="Dictionaries" msprop:Generator_RowDeletedName="DictionariesRowDeleted" msprop:Generator_RowChangedName="DictionariesRowChanged" msprop:Generator_RowClassName="DictionariesRow" msprop:Generator_RowChangingName="DictionariesRowChanging" msprop:Generator_RowEvArgName="DictionariesRowChangeEvent" msprop:Generator_RowEvHandlerName="DictionariesRowChangeEventHandler" msprop:Generator_TableClassName="DictionariesDataTable" msprop:Generator_TableVarName="tableDictionaries" msprop:Generator_RowDeletingName="DictionariesRowDeleting" msprop:Generator_TablePropName="Dictionaries">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DictionaryID" msprop:Generator_UserColumnName="DictionaryID" msprop:Generator_ColumnPropNameInRow="DictionaryID" msprop:Generator_ColumnVarNameInTable="columnDictionaryID" msprop:Generator_ColumnPropNameInTable="DictionaryIDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Collections" />
      <xs:field xpath="mstns:CollectionID" />
    </xs:unique>
    <xs:unique name="PTSPages_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PTSPages" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Files_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Files" />
      <xs:field xpath="mstns:FileID" />
    </xs:unique>
    <xs:unique name="Nodes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Nodes" />
      <xs:field xpath="mstns:NodeID" />
    </xs:unique>
    <xs:unique name="DictionaryContent_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DictionaryContent" />
      <xs:field xpath="mstns:EntryID" />
    </xs:unique>
    <xs:unique name="Dictionaries_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Dictionaries" />
      <xs:field xpath="mstns:DictionaryID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="NODES_PTSPAGES" msdata:parent="Files" msdata:child="PTSPages" msdata:parentkey="FileID" msdata:childkey="FileID" msprop:Generator_UserRelationName="NODES_PTSPAGES" msprop:Generator_RelationVarName="relationNODES_PTSPAGES" msprop:Generator_UserChildTable="PTSPages" msprop:Generator_UserParentTable="Files" msprop:Generator_ParentPropName="FilesRow" msprop:Generator_ChildPropName="GetPTSPagesRows" />
      <msdata:Relationship name="Files_Nodes_FK" msdata:parent="Files" msdata:child="Nodes" msdata:parentkey="FileID" msdata:childkey="FileID" msprop:Generator_UserRelationName="Files_Nodes_FK" msprop:Generator_RelationVarName="relationFiles_Nodes_FK" msprop:Generator_UserChildTable="Nodes" msprop:Generator_UserParentTable="Files" msprop:Generator_ParentPropName="FilesRow" msprop:Generator_ChildPropName="GetNodesRows" />
      <msdata:Relationship name="DICTIONARY_CONTENT" msdata:parent="Dictionaries" msdata:child="DictionaryContent" msdata:parentkey="DictionaryID" msdata:childkey="DictionaryID" msprop:Generator_UserRelationName="DICTIONARY_CONTENT" msprop:Generator_RelationVarName="relationDICTIONARY_CONTENT" msprop:Generator_UserChildTable="DictionaryContent" msprop:Generator_UserParentTable="Dictionaries" msprop:Generator_ParentPropName="DictionariesRow" msprop:Generator_ChildPropName="GetDictionaryContentRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>